package com.lanou.service;


import com.lanou.bean.*;

import java.util.List;

public interface VipInfoService {

    List<VipInfo> selectAllVipInfo(VipInfo vipInfo);

    List<VipInfo> selectAllVipInfo1(VipInfo vipInfo);

    List<Province> selectAllProvince();

    List<VipInfo> selectAllVipInfo2(VipInfo vipInfo);

    List<City> selectAllCityByProvinceId(int provinceId);

    int selectProvinceIdByProvince(String province);

    int selectAddrInfoIdByAddrInfo(String addrInfo);

    int updateAddrInfo(AddrInfo addrInfo);

    int updateByPrimaryKeySelective(VipInfo record);

    List<AddrInfo> selectAddrInfoByPC(AddrInfo addrInfo);

    VipInfo selectVipInfoByAP(String vip_account,String password);

    VipInfo selectVipInfoByVA(String vip_account);

    int insertSelective(VipInfo record);

    //根据银行卡号获取会员账号
    String selectVipNoByBankCardNo(String bankCardNo);

    int updateByVipNoSelective(VipInfo record);

    int updateByIdSelective(VipInfo record);

    CpnUseRecord selectCpnUseRecordByVipNo(String vipNo);

    CpnInfo selectCpnInfoByCpnNo(String cpnNo);

    CpnRecord selectCpnRecordByVipNo(String vipNo);

    int updateByPrimaryKeySelective(BankInfo record);

    VipInfo selectVipInfoByIdCard(String idCard);

    String selectMaxVipNo();

    int insertSelective(AddrInfo record);

    int selectAddrIdByVipNo(String vipNo);

    int insertSelective(BankInfo record);

    //根据省addr_id查询省
    String selectProvinceByAddrId(int addrId);
    //根据市addr_id查询市
    String selectCityByAddrId(int addrId);

    //根据addrid获取省信息
    String selectProvinceByVipNo(int addrid);
    //根据addrid获取市信息
    String selectCityByVipNo(int addrid);


    //根据会员账号获取银行信息
    BankInfo selectBankInfoByVipNo(String vipNo);

    //根据会员id获取会员信息
    VipInfo selectByPrimaryKey(Integer id);

    //根据会员id查询vip_no
    String selectVipNoById(Integer id);


    //根据会员编号更新会员信息(积分减,账户余额减)
    int updateVipInfoPointSumByVipNo(VipInfo vipInfo);
}
